Cannot edit protected cells in data entry form due to design.

Cause:


This is by the design of Microsoft Excel 7.0.

Solution:


Unprotect the worksheet before editing the cells.

To unprotect a worksheet: